package com.ebt.m.data.db;

/**
 * 公司推荐表
 * 
 * @author ZhanWu.Li
 *
 */
public class CorpCompany2 {

	/** 表名 */
	public static final String TABLE_NAME = "cCorpCompany";
	/** 默认排序方式 */
	public static final String DEFAULT_SORT_ORDER = "Alpha ASC";
	/* 列名定义 */
	/** 主键 Type: INTEGER **/
	public static final String ID = "ID";

	/** 合作公司ID */
	public static final String COLUMN_CORPCOMPANY_ID = "CorpCompanyID";

	/** 中文名字 Type: VARCHAR(100) **/
	public static final String COLUMN_CHINANAME = "Name";
	/** 缩写名称 Type: VARCHAR(100) **/
	public static final String COLUMN_SHORTNAME = "ShortName";
	/** 英文名称 Type: VARCHAR(100) **/
	public static final String COLUMN_ENGLISHNAME = "EnglishName";
	/** 首字母 Type: VARCHAR(1) **/
	public static final String COLUMN_ALPHA = "Alpha";
	/** 邮编Type: VARCHAR(10) **/
	public static final String COLUMN_ZIPCODE = "ZipCode";
	/** 公司所在省份 */
	public static final String COLUMN_PROVINCE = "Province";
	/** 公司所在城市 */
	public static final String COLUMN_CITY = "City";
	/** 公司具体地址 */
	public static final String COLUMN_ADDRESS = "Address";
	/** 商标 Type: VARCHAR(200) **/
	public static final String COLUMN_LOGO = "Logo";
	/** 险种百科列表LOGO Type: VARCHAR(200) **/
	public static final String COLUMN_WIKILOGO = "WikiLogo";
	/** apk地址 Type: VARCHAR(200) **/
	public static final String COLUMN_APKRES = "ApkRes";
	/** 注册资本 Type: VARCHAR(100) **/
	public static final String COLUMN_REGISTEREDCAPITAL = "RegisteredCapital";
	/** 注册地 Type: VARCHAR(100) **/
	public static final String COLUMN_REGISTEREDPLACE = "RegisteredPlace";
	/** 注册时间 Type: VARCHAR(100) **/
	public static final String COLUMN_REGISTEREDDATE = "RegisteredDate";
	/** 经营范围 Type: VARCHAR(500) **/
	public static final String COLUMN_BUSINESSSCOPE = "BusinessScope";
	/** 经营区域 Type: VARCHAR(500) **/
	public static final String COLUMN_BUSINESSREGIONS = "BusinessRegions";
	/** 法定代表人 Type: VARCHAR(100) **/
	public static final String COLUMN_ARTIFICIALPERSON = "ArtificialPerson";
	/** 客服电话 Type: VARCHAR(100) **/
	public static final String COLUMN_SERVICEPHONE = "ServicePhone";
	/** 投诉电话 Type: VARCHAR(100) **/
	public static final String COLUMN_COMPLAINTSPHONE = "ComplaintsPhone";
	/** 官网网址 Type: VARCHAR(100) **/
	public static final String COLUMN_OFFICIALWEBSITE = "OfficialWebsite";
	/** 合作开始时间 Type: DATETIME **/
	public static final String COLUMN_CORPSTARTDATE = "CorpStartDate";
	/** 合作结束时间 Type: DATETIME **/
	public static final String COLUMN_CORPENDDATE = "CorpEndDate";
	/** 是否显示 Type: INTEGER **/
	public static final String COLUMN_ISSHOWN = "IsShown";
	/** 离线数量 Type: Varchar **/
	public static final String COLUMN_OFFLINEPRDCTCNT = "OffLinePrdctCnt";

	/** 创建日期 Type: DATETIME **/
	public static final String CREATE_TIME = "CreateTime";
	/** 更新日期 Type: DATETIME **/
	public static final String UPDATE_TIME = "UpdatedDateTime";
	/** 本地版本号 Type: INT **/
	public static final String COLUMN_LOCALCOMPANYVERSION = "LocalCompanyVersion";

	/** 合作公司数据信息版本号 Type: INT **/
	public static final String COLUMN_CORPCOMPANY_VERSION = "CompanyVersion";

	/** 服务器公司记录更新时间 Type: DATE **/
	public static final String COLUMN_COMPANYUPDATETIME = "CompanyUpdateTime";
	/** 本地公司记录更新时间 Type: INTEGER **/
	public static final String COLUMN_LOCALCOMPANYUPDATETIME = "LocalCompanyUpdateTime";

	/** 品牌公司的URL Type: VARCHAR **/
	public static final String COLUMN_RESPREFIX = "ResPrefix";
	/* 离线时间有效性标识-0不使用1使用 */
	public static final String COLUMN_OFFLINETIMESPANFLAG = "OfflineTimeSpanFlag";
	/* 离线时间数值-服务器默认72小时 */
	public static final String COLUMN_OFFLINETIMESPAN = "OfflineTimeSpan";

}